#!/bin/bash
APP=edu

# 如果是输入的日期按照取输入日期；如果没输入日期取当前时间的前一天
if [ -n "$2" ] ;then
    do_date=$2
else
    do_date=`date -d "-1 day" +%F`
fi

sql="
"

case $1 in
    "sql" )
        /opt/module/hive/bin/hive -e "use ${APP};$sql"
    ;;


    "all" )
        /opt/module/hive/bin/hive -e "
        use ${APP};
        $sql

        "
    ;;
esac